|
127 Search Results Found |
1 |
Forum: Marketplace «»
Posted on: Fri, 12 June 2020 12:15 «»
By: Michel Cadot
Re: McDP: like expdp/impdp Data Pump programs and much more
…
DESCRIBE command
The DESCRIBE command is another way to get information about a Data Pump job.
The syntaxes of this command are:
McDP [<logon>] { -desc | --describe } [<schema>.]<dp job> [[-opt] <display/trace option>]
…
|
2 |
Forum: Forms «»
Posted on: Sat, 13 August 2022 03:29 «»
By: sasipalarivattom
Re: Files generated on server with sufix
…report in URL
like http://WIN-SERV:9002/reports/rwservlet?server=rep_server1&report=test.rdf&destype=file&desformat=html&userid=scott/ti ger@orcl&desname=c:\rep1.html
is it also appending something to the output file…
|
3 |
Forum: Forms «»
Posted on: Mon, 17 June 2019 10:44 «»
By: alhakimy
Re: How make imp button
…want
1- drop user
2- create user
3-grant dba to user
4- imp file.dmp
I used this code in 6i but now with 10g did not work
forms_ddl('conn system/manager');
forms_ddl('drop user scott cascade');
forms_ddl('create user scott identified by …
|
4 |
Forum: Replication «»
Posted on: Tue, 13 March 2018 02:22 «»
By: ssumesh
Oracle Golden Gate replication
…All,
We are trying to store counts of DML (DELETE,INSERT & UPDATE) performed on each table via Oracle Golden gate replication.
For example, if there are 1 insert, 1 update performed at source table. Then, in Target it will captured as below.
…
|
5 |
Forum: JDeveloper, Java & XML «»
Posted on: Mon, 19 February 2018 18:05 «»
By: BlackSwan
Re: Using IDE Database Connections in Java code
…is a working example of how to use Java to query Oracle DB
bcm@bcm-laptop:~$ cat Conn.java
import java.sql.*;
class Conn {
public static void main (String[] args) throws Exception
{
Class.forName ("oracle.jdbc.OracleDriver");
…
|
6 |
Forum: Server Utilities «»
Posted on: Thu, 29 December 2016 18:17 «»
By: Barbara Boehmer
Re: SQL Loader double quotes in clob data (3 threads from 2 sub-forums merged by bb)
…double quotes are not a problem.
The carriage returns do present a problem. You need to have some way to tell where the record ends, such as a record delimiter or something at the beginning or end of each row that tells if to continue or concatenating…
|
7 |
Forum: Marketplace «»
Posted on: Mon, 22 August 2016 10:13 «»
By: Michel Cadot
Re: McDP: like expdp/impdp Data Pump programs and much more
…
CONTENT command
Now I want to know what's inside the dump, more I want the DDL, more I want not all but some of these DDL and I want to apply some transformation on them.
This is possible with McDP using the CONTENT command.
Its syntax is:
McDP…
|
8 |
Forum: Marketplace «»
Posted on: Mon, 22 August 2016 10:13 «»
By: Michel Cadot
Re: McDP: like expdp/impdp Data Pump programs and much more
…
CONTINUE/RESTART commands
Now that we saw how to stop a job, can we restart it? Yes, using the RESTART or CONTINUE command.
Its syntax is:
McDP [<logon>] { -r | --restart | --continue } [<schema>.]<dp job> [<service name>…
|
9 |
Forum: Marketplace «»
Posted on: Mon, 22 August 2016 10:12 «»
By: Michel Cadot
Re: McDP: like expdp/impdp Data Pump programs and much more
…
STOP/SUSPEND and KILL commands
We saw how to get information about Data Pump jobs, now we start commands to manage them.
The first set of commands allow to stop running jobs.
Their syntax are:
McDP [<logon>] { -s | --stop | --suspend…
|
10 |
Forum: Server Utilities «»
Posted on: Mon, 01 August 2016 14:15 «»
By: Michel Cadot
Re: Copy database to another computer
…
Export:
E:\Temp\Listing>expdp help=y
Export: Release 11.2.0.4.0 - Production on Jeu. Juin 23 13:51:08 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
The Data Pump export utility provides a mechanism for…
|
11 |
Forum: JDeveloper, Java & XML «»
Posted on: Wed, 25 May 2016 10:49 «»
By: tolupuluri
Re: Need to insert data from XML file into Oracle Table (very urgent)
…Hi, this approach is working fine.
But, when I create the XML table using:
CREATE TABLE test_xml OF XMLTYPE
XMLTYPE STORE AS SECUREFILE BINARY XML;
And try to isnert the data like this:
INSERT INTO test_xml VALUES(
xmltype(bfilename('TESTING…
|
12 |
Forum: JDeveloper, Java & XML «»
Posted on: Wed, 25 May 2016 01:57 «»
By: Barbara Boehmer
Re: Need to insert data from XML file into Oracle Table (very urgent)
…of the problem is that your XML is written in such a manner that there is no way to tell which Reading belongs to which row.
If you were to fix your XML like so:
SCOTT@orcl_12.1.0.2.0> CREATE TABLE test_xml AS
2 SELECT XMLTYPE
3…
|
13 |
Forum: Server Utilities «»
Posted on: Tue, 07 October 2014 14:13 «»
By: BlackSwan
Re: Tablespace and Schema info from dumpfile
…or incapable to just Read The Fine Manual?
http://docs.oracle.com/database/121/SUTIL/dp_import.htm#SUTIL300
[oracle@localhost ~]$ impdp help=yes
Import: Release 11.2.0.2.0 - Production on Tue Oct 7 12:12:08 2014
Copyright (c) 1982, 2009, …
|
14 |
Forum: Forms «»
Posted on: Wed, 05 December 2012 02:51 «»
By: Akarsh
sql loader with forms
…am using oracle forms 10g on windows 7 32 bit.
i want to load data from oracle form to oracle database.
i have written the following code on Push Buttons When-Button-Pressed trigger.
declare
usid varchar2(10):= get_application_property(username…
|
15 |
Forum: Server Utilities «»
Posted on: Sun, 15 April 2012 11:39 «»
By: BlackSwan
Re: Increasing parallel process in impdp in runtime
…
bcm@bcm-laptop:~$ impdp help=yes
Import: Release 11.2.0.1.0 - Production on Sun Apr 15 09:37:52 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
The Data Pump Import utility provides a mechanism for …
|
16 |
Forum: Programming Interfaces «»
Posted on: Mon, 19 March 2012 12:48 «»
By: BlackSwan
Re: JDBC Connection problem on Windows 2008 R2
…
bcm@bcm-laptop:~$ cat Conn.java
import java.sql.*;
class Conn {
public static void main (String[] args) throws Exception
{
Class.forName ("oracle.jdbc.OracleDriver");
Connection conn = DriverManager.getConnection
("…
|
17 |
Forum: Forms «»
Posted on: Thu, 15 March 2012 06:46 «»
By: owais_baba
Re: How to open a URL from oracle forms ?
…example
DECLARE
rep_url varchar2(2000);
BEGIN
rep_url:='/dev60cgi/rwcgi60?server=
repserv6i&report=
reptest.rdf'
||'&desformat=
htmlcss&destype=
…
|
18 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 25 January 2012 12:27 «»
By: Barbara Boehmer
Re: ORA-30506: system triggers cannot be based on tables or views
…Michel,
I don't think I said that clearly. It appears to be the schema that you are connected as, when you create the trigger using just schema, that counts, not the schema in the schema.trigger_name that counts. If you create the same system.…
|
19 |
Forum: Server Utilities «»
Posted on: Sun, 25 September 2011 22:33 «»
By: BlackSwan
Re: indexes parameters original imp
…all else fails, Read The Fine Help
You can accomplish the same, but using different syntax.
bcm@bcm-laptop:~$ expdp help=yes
Export: Release 11.2.0.1.0 - Production on Sun Sep 25 20:31:56 2011
Copyright (c) 1982, 2009, Oracle and/or its …
|
20 |
Forum: Server Administration «»
Posted on: Wed, 25 May 2011 13:34 «»
By: Michel Cadot
Re: Deleting unwanted SYS shema objects
…- Never ever use SYS (or SYSDBA) but for maintenance purpose (startup, shutdown, backup, recover)
- SYS/SYSDBA is special
- SYS/SYSDBA is Oracle proprietary (try to open a SR/TAR starting with "i did that with SYS/SYSDBA" and you'll see the …
|
21 |
Forum: Server Utilities «»
Posted on: Wed, 27 October 2010 06:52 «»
By: goracle9
Re: Upgrade 8i to 10g
…IMP-00017: following statement failed with ORACLE error 1119:
"CREATE TABLESPACE "RBS" DATAFILE 'C:\ORACLE\ORADATA\ARMADA\RBS01.DBF' SIZE"
" 545259520 AUTOEXTEND ON NEXT 5242880 MAXSIZE 32767M DEFAULT STORAG"
&…
|
22 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 16 September 2010 20:45 «»
By: Barbara Boehmer
Re: multi column distinct
…analytic function like row_number or rank is exactly what you need. You can use an analytic function to partition the rows by userid, lastname, and firstname, then number the rows within each such partition, ordered by rownum or rowid or whatever unique …
|
23 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 14 July 2010 18:26 «»
By: Barbara Boehmer
Re: Split the values from column
…you always have a set of characters followed by a set of digits, then you could use translate and replace to select from userid, replacing all the digits with null to get the user and replacing all the characters with null to get the id, as shown below…
|
24 |
Forum: Server Utilities «»
Posted on: Sat, 19 June 2010 03:02 «»
By: Michel Cadot
Re: Import 9i dmp Into 10g
…
Good! so it works.
C:\>imp help=y
Import: Release 10.2.0.4.0 - Production on Sam. Juin 19 10:01:50 2010
Copyright (c) 1982, 2007, Oracle. All rights reserved.
You can let Import prompt you for parameters by entering the IMP
…
|
25 |
Forum: Server Utilities «»
Posted on: Wed, 28 April 2010 04:55 «»
By: Michel Cadot
Re: Imp db oracle
…C:\>imp help=y
Import: Release 10.2.0.4.0 - Production on Wed Apr 28 11:54:48 2010
Copyright (c) 1982, 2007, Oracle. All rights reserved.
You can let Import prompt you for parameters by entering the IMP
command followed by your username/…
|
26 |
Forum: Server Utilities «»
Posted on: Tue, 20 April 2010 02:54 «»
By: Michel Cadot
Re: Export Schema failed
…that are appropriate to what you want to export.
Maybe the following and the documentation may help you to know what to do:
C:\>exp help=y
Export: Release 10.2.0.4.0 - Production on Tue Apr 20 09:54:36 2010
Copyright (c) 1982, 2007, Oracle. …
|
27 |
Forum: Server Utilities «»
Posted on: Mon, 25 January 2010 23:15 «»
By: BlackSwan
Re: can we do import like
…>my question is can i do import of particular table from full exported database file.
Yes, you can or at least I could.
Since you included no details, I can't provide any details in return.
imp help=yes
Import: Release 10.2.0.1.0 - …
|
28 |
Forum: Server Administration «»
Posted on: Mon, 11 January 2010 22:41 «»
By: BlackSwan
Re: Connection log for bequeath connection
…then did
SQL> CONNECT SCOTT/TIGER
which produced following audit log file
cat /u01/app/oracle/admin/v102/adump/ora_2278.aud
Audit file /u01/app/oracle/admin/v102/adump/ora_2278.aud
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - …
|
29 |
Forum: Server Utilities «»
Posted on: Sat, 16 May 2009 09:03 «»
By: shrinika
Impdp with multiple dump file directories
…Hello,
I am exporting the schema and place the dump file in three different directories...
At the end,i wanted to load the dump files into another database.
Here is the export parfile content. Export is successfully completed.
userid=system/…
|
30 |
Forum: Server Utilities «»
Posted on: Tue, 17 March 2009 00:36 «»
By: Michel Cadot
Re: Statistics gathered during import
…C:\>imp help=y
Import: Release 10.2.0.4.0 - Production on Mar. Mars 17 06:35:18 2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.
You can let Import prompt you for parameters by entering the IMP
command followed by your …
|
31 |
Forum: Reports & Discoverer «»
Posted on: Thu, 19 February 2009 12:50 «»
By: Littlefoot
Re: New to oracle..pls help to open report from form
Something like
web.show_document('http://127.0.0.1:8889/reports/rwservlet?
report=c:\some_report.jsp&destype=cache&desformat=htmlcss
&userid=scott/tiger@ora10
&par_year='||:my_year_parameter);(note the last line).
|
32 |
Forum: Reports & Discoverer «»
Posted on: Mon, 17 November 2008 11:09 «»
By: shahis_ks
Error while generating reports from forms - 499 Oracle SSO
…p_report_server_name);
Web.show_document ('/reports/rwservlet?server=rep_auh0030482_app_serv3¶mform=no&REPORT=C:\TESTFORM.rdf&destype=cache&desformat=html &userid=scott/tiger@orcl','_blank');
pls help me on this issue…
|
33 |
Forum: Server Utilities «»
Posted on: Wed, 22 October 2008 01:44 «»
By: Michel Cadot
Re: Imp
…C:\>imp help=y
Import: Release 10.2.0.4.0 - Production on Wed Oct 22 08:44:19 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
You can let Import prompt you for parameters by entering the IMP
command followed by your username/…
|
34 |
Forum: Reports & Discoverer «»
Posted on: Wed, 15 October 2008 22:45 «»
By: vikasg2006
How to run report in 10g
…&desformat=htmlcss&destype=cache&userid=scott/tiger@orcl ’||’¶mform=no’;
WEB.SHOW_DOCUMENT(rep_url,’_blank’);
END;
My question is.. Is application server is required.? I am using this in my home pc, …
|
35 |
Forum: Windows «»
Posted on: Mon, 13 October 2008 09:17 «»
By: ora1980
handling errors in batch file
… ihave a .bat file, in which i am using sqlldr to load into a staging table from csv file, and then using merge to insert / update into target table
i have 2 doubts
1) my first doubt is regarding batch script..how to handle the errorlevels which are …
|
36 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 13 October 2008 01:50 «»
By: sydney1
Re: Issue with Trigger
Hi Rajuvan,
INSERT INTO "SCOTT"."TEST1" ("USERNAME" ,"USERID" ,"DATEFIELD"
)
VALUES
('nick' ,'13' ,TO_DATE('', 'dd-Mon-yyyy HH:MI:SS AM')
);
commit;
Rgds
SYD
|
37 |
Forum: Server Utilities «»
Posted on: Wed, 08 October 2008 09:30 «»
By: Michel Cadot
Re: How to export data for single employee?
…C:\>exp help=y
Export: Release 10.2.0.4.0 - Production on Wed Oct 8 16:29:46 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
You can let Export prompt you for parameters by entering the EXP
command followed by your username/…
|
38 |
Forum: Client Tools «»
Posted on: Sun, 05 October 2008 11:43 «»
By: hemanthjava
Help for Configuring my Oracle Net Manager
…All,
I need help with Configuring my Oracle Net Manager.
I have done the following Steps;
1. I have opened Oracle Net Manager.
2. Clicked on Service Naming
3. Clicked the Add(+) button on the left to add new Service Name
4. Typed "orcl&…
|
39 |
Forum: Forms «»
Posted on: Mon, 01 September 2008 01:31 «»
By: kishani79
Re: Form Error
…your reply.I diid all those things.But its not working.web page display banck and its web address contain
http://Nisha-pc:8889/forms90/f90servlet?form=C:/DevSuiteHome_1/forms90&userid=scott/tiger@Oracle&separateframe=true
what happend it…
|
40 |
Forum: Security «»
Posted on: Wed, 06 August 2008 02:19 «»
By: ward2009
Re: Wanna help please
my problem is
this is the url
form=C:\Ora_Work\MODULE1.fmx&userid=SCOTT/TIGER@dba&buffer_records=NO&debug_messages=NO&array=YES&query_only=NO&quiet=NO&RENDER=YES
|